Run Migrations in BigDb

Run database setup, upgrades, & downgrade.

@see_files(docs/dev/CreateMigrations.md; Create Migrations, docs/dev/StoredSql.md; Stored SQL, docs/CRUD.md; CRUD)

Docs

• Migrate Via CLI
• Migrate in PHP

Migrate via CLI

You must first create a bin script for your BigDb setup. See @see_file(docs/dev/Cli.md, CLI)

// list available migrations
bin/yourdb list-migrations

// syntax
bin/yourdb migrate [current_version] [target_version]

// initialize database, from version zero to version one.
bin/yourdb migrate 0 1

// upgrade from version 1 to version 3
bin/yourdb migrate1 3

Migrate in PHP

Initialize the library's databse & call $db->migrate(old_version, new_version)

<?php
$pdo = new \PDO('mysql:dbname='.$db_name.';host='.$db_host, $user_name, $password);

$db = new \Tlf\BigDb\Test\ArticleDb($pdo); 

// initialize database
$db->migrate(0,1); 

// upgrade from version 1 to version 3
$db->migrate(1,3);